package cn.com.nthotline.db;

public class DBOperatedConstant {

	public static final int DATABASE_VERSION = 1;

	public final static String DATABASE_NAME = "ntr_manuscript.db3";
	
	public static final String UPDATE_SQL = "update %s set %s='%s' where %s='%s'";

	public static final String UPDATE_MULTI_SQL = "update %s set %s where %s='%s'";

	public static final String QUERY_SQL = "select %s from %s ORDER BY %s DESC";

	public static final String QUERY_SQL_WITHOUTORDER = "select %s from %s";

	public static final String QUERY_String_ID_SQL = "select %s from %s where %s='%s' ORDER BY %s DESC";

	public static final String QUERY_STRING_ID_SQL_NO_DESC = "select %s from %s where %s='%s'";

	public static final String QUERY_STRING_SQL_NO_DESC = "select * from %s where %s='%s'";

	public static final String QUERY_Muti_ID_SQL = "select %s from %s where %s='%s' and %s='%s'";
	
	public static final String QUERY_MUTI_WHERE_CLAUSE_SQL = "select %s from %s where %s";

	public static final String QUERY_COUNT_SQL = "select count(*) from %s";

	public static final String QUERY_COUNT_SQL_BY_KEY = "select count(*) from %s where %s='%s'";
	
	public static final String DELETE_SQL = "delete from %s where %s=%s";
	
	public static final String DELETE_ALL_SQL = "delete from %s";

}
